Pandas Profiling Report

Dataset statistics

Number of variables	37
Number of observations	806415
Missing cells	18027
Missing cells (%)	0.1%
Duplicate rows	39946
Duplicate rows (%)	5.0%
Total size in memory	212.3 MiB
Average record size in memory	276.0 B

Variable types

Categorical	20
Numeric	13
Boolean	4

Alerts

`cancelled` has constant value "False"	Constant
`bus.wifi` has constant value "False"	Constant
Dataset has 39946 (5.0%) duplicate rows	Duplicates
`Stop_Name` has a high cardinality: 1487 distinct values	High cardinality
`street.name` has a high cardinality: 290 distinct values	High cardinality
`cross-street.name` has a high cardinality: 724 distinct values	High cardinality
`Bus_Variant` has a high cardinality: 242 distinct values	High cardinality
`Destination_Name` has a high cardinality: 150 distinct values	High cardinality
`Route_Name` has a high cardinality: 225 distinct values	High cardinality
`Route_Description` has a high cardinality: 81 distinct values	High cardinality
`key` has a high cardinality: 16008 distinct values	High cardinality
`times.departure.scheduled` has a high cardinality: 7389 distinct values	High cardinality
`times.departure.estimated` has a high cardinality: 7391 distinct values	High cardinality
`variant.key` has a high cardinality: 108 distinct values	High cardinality
`variant.name` has a high cardinality: 107 distinct values	High cardinality
`times.arrival.scheduled` has a high cardinality: 7389 distinct values	High cardinality
`times.arrival.estimated` has a high cardinality: 7391 distinct values	High cardinality
`Stop_Number` is highly correlated with `centre.utm.y` and 1 other fields	High correlation
`centre.utm.x` is highly correlated with `centre.geographic.longitude`	High correlation
`centre.utm.y` is highly correlated with `Stop_Number` and 1 other fields	High correlation
`centre.geographic.latitude` is highly correlated with `Stop_Number` and 1 other fields	High correlation
`centre.geographic.longitude` is highly correlated with `centre.utm.x`	High correlation
`Delay_Time` is highly correlated with `IsDelayed`	High correlation
`IsDelayed` is highly correlated with `Delay_Time`	High correlation
`Stop_Number` is highly correlated with `centre.utm.y` and 1 other fields	High correlation
`centre.utm.x` is highly correlated with `centre.geographic.longitude`	High correlation
`centre.utm.y` is highly correlated with `Stop_Number` and 1 other fields	High correlation
`centre.geographic.latitude` is highly correlated with `Stop_Number` and 1 other fields	High correlation
`centre.geographic.longitude` is highly correlated with `centre.utm.x`	High correlation
`Number_of_Stoppages` is highly correlated with `Variants_Count`	High correlation
`Variants_Count` is highly correlated with `Number_of_Stoppages`	High correlation
`centre.utm.x` is highly correlated with `centre.geographic.longitude`	High correlation
`centre.utm.y` is highly correlated with `centre.geographic.latitude`	High correlation
`centre.geographic.latitude` is highly correlated with `centre.utm.y`	High correlation
`centre.geographic.longitude` is highly correlated with `centre.utm.x`	High correlation
`Delay_Time` is highly correlated with `IsDelayed`	High correlation
`IsDelayed` is highly correlated with `Delay_Time`	High correlation
`bus.wifi` is highly correlated with `bus.bike-rack` and 9 other fields	High correlation
`bus.bike-rack` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`cross-street.type` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`Route_Description` is highly correlated with `bus.wifi` and 2 other fields	High correlation
`side` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`direction` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`cancelled` is highly correlated with `bus.wifi` and 9 other fields	High correlation
`coverage` is highly correlated with `bus.wifi` and 2 other fields	High correlation
`Types_of_Features_Count` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`IsDelayed` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`street.type` is highly correlated with `bus.wifi` and 1 other fields	High correlation
`Stop_Number` is highly correlated with `street.type` and 10 other fields	High correlation
`direction` is highly correlated with `street.type` and 2 other fields	High correlation
`street.key` is highly correlated with `street.type` and 2 other fields	High correlation
`street.type` is highly correlated with `Stop_Number` and 10 other fields	High correlation
`cross-street.key` is highly correlated with `street.type` and 1 other fields	High correlation
`cross-street.type` is highly correlated with `Stop_Number` and 10 other fields	High correlation
`centre.utm.x` is highly correlated with `Stop_Number` and 8 other fields	High correlation
`centre.utm.y` is highly correlated with `Stop_Number` and 9 other fields	High correlation
`centre.geographic.latitude` is highly correlated with `Stop_Number` and 9 other fields	High correlation
`centre.geographic.longitude` is highly correlated with `Stop_Number` and 8 other fields	High correlation
`Variants_Serviced_Count` is highly correlated with `cross-street.type` and 3 other fields	High correlation
`Number_of_Stoppages` is highly correlated with `Stop_Number` and 8 other fields	High correlation
`Types_of_Features_Count` is highly correlated with `Variants_Serviced_Count` and 1 other fields	High correlation
`Route_Number` is highly correlated with `Stop_Number` and 5 other fields	High correlation
`Variants_Count` is highly correlated with `Stop_Number` and 9 other fields	High correlation
`Route_Description` is highly correlated with `Stop_Number` and 14 other fields	High correlation
`coverage` is highly correlated with `Stop_Number` and 6 other fields	High correlation
`bus.key` is highly correlated with `bus.bike-rack`	High correlation
`bus.bike-rack` is highly correlated with `bus.key`	High correlation
`side` has 10193 (1.3%) missing values	Missing
`Delay_Time` has 754106 (93.5%) zeros	Zeros

Reproduction

Analysis started	2022-12-27 23:51:31.318470
Analysis finished	2022-12-27 23:54:40.730600
Duration	3 minutes and 9.41 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Stop_Name
Categorical

HIGH CARDINALITY

Distinct	1487
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Northbound De Baets at Camiel Sys North	12635
Eastbound Headmaster at Leatherwood East	10208
Eastbound Blue Mountain at Copperstone	9225
Westbound Pandora at Hoka	6342
Eastbound Camiel Sys at Ray Marius	6194
Other values (1482)	761811

Length

Max length	70
Median length	31
Mean length	32.14702852
Min length	22

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Eastbound Graham at Smith
2nd row	Eastbound Graham at Smith
3rd row	Eastbound Graham at Smith
4th row	Eastbound Graham at Smith
5th row	Eastbound Graham at Smith

Common Values

Value	Count	Frequency (%)
Northbound De Baets at Camiel Sys North	12635	1.6%
Eastbound Headmaster at Leatherwood East	10208	1.3%
Eastbound Blue Mountain at Copperstone	9225	1.1%
Westbound Pandora at Hoka	6342	0.8%
Eastbound Camiel Sys at Ray Marius	6194	0.8%
Eastbound Dafoe at U of M Station	6020	0.7%
Southbound Ashworth at Coombs	5880	0.7%
Northbound Balmoral at Balmoral Station (42)	5688	0.7%
Southbound De La Seigneurie at Desjardins	5250	0.7%
Westbound Morley at Osborne	5208	0.6%
Other values (1477)	733765	91.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
at	806415	21.3%
eastbound	237464	6.3%
westbound	218341	5.8%
southbound	187499	4.9%
northbound	163111	4.3%
de	50999	1.3%
east	41984	1.1%
west	33171	0.9%
st	30985	0.8%
la	28296	0.7%
Other values (891)	1990329	52.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Stop_Number
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1491
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41447.24655

Minimum	10010
Maximum	62017
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	10010
5-th percentile	10117
Q1	30807
median	50316
Q3	50873
95-th percentile	60845
Maximum	62017
Range	52007
Interquartile range (IQR)	20066

Descriptive statistics

Standard deviation	14901.21393
Coefficient of variation (CV)	0.3595224091
Kurtosis	-0.4554647988
Mean	41447.24655
Median Absolute Deviation (MAD)	9690
Skewness	-0.8281039003
Sum	3.342368132 × 10¹⁰
Variance	222046176.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50874	12635	1.6%
40626	10208	1.3%
50140	9225	1.1%
40099	6342	0.8%
50994	6194	0.8%
61254	6020	0.7%
50944	5880	0.7%
10846	5688	0.7%
50783	5250	0.7%
10033	5208	0.6%
Other values (1481)	733765	91.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10010	1800	0.2%
10011	2304	0.3%
10012	702	0.1%
10013	366	< 0.1%
10014	492	0.1%
10017	1044	0.1%
10018	408	0.1%
10021	240	< 0.1%
10022	654	0.1%
10023	96	< 0.1%

Value	Count	Frequency (%)
62017	2296	0.3%
62013	238	< 0.1%
62012	56	< 0.1%
62011	112	< 0.1%
62010	7	< 0.1%
62003	12	< 0.1%
61282	10	< 0.1%
61280	44	< 0.1%
61279	110	< 0.1%
61254	6020	0.7%

direction
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Eastbound	237464
Westbound	218341
Southbound	187499
Northbound	163111

Length

Max length	10
Median length	9
Mean length	9.434776139
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Eastbound
2nd row	Eastbound
3rd row	Eastbound
4th row	Eastbound
5th row	Eastbound

Common Values

Value	Count	Frequency (%)
Eastbound	237464	29.4%
Westbound	218341	27.1%
Southbound	187499	23.3%
Northbound	163111	20.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
eastbound	237464	29.4%
westbound	218341	27.1%
southbound	187499	23.3%
northbound	163111	20.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

side
Categorical

HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	10193
Missing (%)	1.3%
Memory size	12.3 MiB

Nearside	361958
Farside	296410
Nearside Opposite	71144
Farside Opposite	54084
Direct Opposite	12626

Length

Max length	17
Median length	8
Mean length	9.086305076
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nearside
2nd row	Nearside
3rd row	Nearside
4th row	Nearside
5th row	Nearside

Common Values

Value	Count	Frequency (%)
Nearside	361958	44.9%
Farside	296410	36.8%
Nearside Opposite	71144	8.8%
Farside Opposite	54084	6.7%
Direct Opposite	12626	1.6%
(Missing)	10193	1.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
nearside	433102	46.4%
farside	350494	37.5%
opposite	137854	14.8%
direct	12626	1.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

street.key
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	294
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1618162.629

Minimum	4
Maximum	70002223
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	4
5-th percentile	171
Q1	997
median	2063
Q3	3136
95-th percentile	3879
Maximum	70002223
Range	70002219
Interquartile range (IQR)	2139

Descriptive statistics

Standard deviation	9132418.636
Coefficient of variation (CV)	5.643696421
Kurtosis	30.05817891
Mean	1618162.629
Median Absolute Deviation (MAD)	1066
Skewness	5.58858277
Sum	1.304910616 × 10¹²
Variance	8.340107014 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
997	26389	3.3%
52	26360	3.3%
3136	22655	2.8%
3059	21569	2.7%
296	21125	2.6%
1694	20800	2.6%
2747	18979	2.4%
3578	18726	2.3%
1122	18073	2.2%
2551	17832	2.2%
Other values (284)	593907	73.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1217	0.2%
36	235	< 0.1%
52	26360	3.3%
56	2930	0.4%
92	10	< 0.1%
118	966	0.1%
128	7730	1.0%
141	14	< 0.1%
171	16901	2.1%
174	930	0.1%

Value	Count	Frequency (%)
70002223	594	0.1%
70002163	2406	0.3%
50002021	534	0.1%
50002006	1530	0.2%
50002005	96	< 0.1%
50002004	2772	0.3%
50001002	148	< 0.1%
50000302	1800	0.2%
50000297	1040	0.1%
50000291	380	< 0.1%

street.name
Categorical

HIGH CARDINALITY

Distinct	290
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

De La Seigneurie Boulevard	26389
Aldgate Road	26360
Rougeau Avenue	22655
Pandora Avenue	21815
River Road	21569
Other values (285)	687627

Length

Max length	26
Median length	14
Mean length	15.01888978
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Graham Avenue
2nd row	Graham Avenue
3rd row	Graham Avenue
4th row	Graham Avenue
5th row	Graham Avenue

Common Values

Value	Count	Frequency (%)
De La Seigneurie Boulevard	26389	3.3%
Aldgate Road	26360	3.3%
Rougeau Avenue	22655	2.8%
Pandora Avenue	21815	2.7%
River Road	21569	2.7%
Beaverhill Boulevard	21125	2.6%
Headmaster Row	20800	2.6%
Taylor Avenue	18726	2.3%
Dugald Road	18073	2.2%
Morley Avenue	17832	2.2%
Other values (280)	591071	73.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
avenue	214118	11.8%
road	196165	10.8%
street	130691	7.2%
boulevard	121365	6.7%
drive	67847	3.7%
de	43709	2.4%
la	26719	1.5%
seigneurie	26389	1.4%
aldgate	26360	1.4%
taylor	23774	1.3%
Other values (312)	943986	51.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

street.type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	5211
Missing (%)	0.6%
Memory size	12.3 MiB

Avenue	214118
Road	203893
Street	130691
Boulevard	121365
Drive	67847
Other values (12)	63290

Length

Max length	9
Median length	6
Mean length	5.781548769
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Avenue
2nd row	Avenue
3rd row	Avenue
4th row	Avenue
5th row	Avenue

Common Values

Value	Count	Frequency (%)
Avenue	214118	26.6%
Road	203893	25.3%
Street	130691	16.2%
Boulevard	121365	15.0%
Drive	67847	8.4%
Row	20800	2.6%
Crescent	10659	1.3%
Place	8910	1.1%
Loop	8212	1.0%
Terminal	6997	0.9%
Other values (7)	7712	1.0%
(Missing)	5211	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
avenue	214118	26.7%
road	203893	25.4%
street	130691	16.3%
boulevard	121365	15.1%
drive	67847	8.5%
row	20800	2.6%
crescent	10659	1.3%
place	8910	1.1%
loop	8212	1.0%
terminal	6997	0.9%
Other values (7)	7712	1.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

cross-street.key
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	727
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	347556.112

Minimum	1
Maximum	50002001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	1
5-th percentile	218
Q1	976
median	2063
Q3	3062
95-th percentile	4173
Maximum	50002001
Range	50002000
Interquartile range (IQR)	2086

Descriptive statistics

Standard deviation	4141724.846
Coefficient of variation (CV)	11.91670842
Kurtosis	139.7341164
Mean	347556.112
Median Absolute Deviation (MAD)	1052
Skewness	11.90519873
Sum	2.80274462 × 10¹¹
Variance	1.71538847 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
616	12635	1.6%
1766	11893	1.5%
2119	10416	1.3%
2884	9783	1.2%
2039	9589	1.2%
3780	9528	1.2%
954	9294	1.2%
861	9225	1.1%
1932	8868	1.1%
3399	8724	1.1%
Other values (717)	706460	87.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4193	0.5%
8	6	< 0.1%
16	436	0.1%
21	539	0.1%
29	192	< 0.1%
36	258	< 0.1%
39	6	< 0.1%
40	1611	0.2%
52	1211	0.2%
65	115	< 0.1%

Value	Count	Frequency (%)
50002001	2017	0.3%
50001002	90	< 0.1%
50001001	492	0.1%
50000262	2948	0.4%
50000021	25	< 0.1%
4934	2908	0.4%
4930	192	< 0.1%
4874	56	< 0.1%
4868	7	< 0.1%
4855	112	< 0.1%

cross-street.name
Categorical

HIGH CARDINALITY

Distinct	724
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Camiel Sys Street	12635
Hoka Street	11893
Leatherwood Crescent	10416
Plessis Road	9783
Lagimodiere Boulevard	9589
Other values (719)	752099

Length

Max length	26
Median length	14
Mean length	14.64330153
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Smith Street
2nd row	Smith Street
3rd row	Smith Street
4th row	Smith Street
5th row	Smith Street

Common Values

Value	Count	Frequency (%)
Camiel Sys Street	12635	1.6%
Hoka Street	11893	1.5%
Leatherwood Crescent	10416	1.3%
Plessis Road	9783	1.2%
Lagimodiere Boulevard	9589	1.2%
Warde Avenue	9528	1.2%
Dakota Street	9294	1.2%
Copperstone Crescent	9225	1.1%
Kenaston Boulevard	8868	1.1%
Southglen Boulevard	8724	1.1%
Other values (714)	706460	87.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	209219	12.0%
avenue	136528	7.8%
road	117132	6.7%
drive	103416	5.9%
crescent	80830	4.6%
boulevard	53041	3.0%
bay	34451	2.0%
place	20535	1.2%
park	18497	1.1%
lane	13529	0.8%
Other values (764)	959795	54.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

cross-street.type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	823
Missing (%)	0.1%
Memory size	12.3 MiB

Street	209219
Avenue	136528
Road	120572
Drive	101399
Crescent	80706
Other values (16)	157168

Length

Max length	9
Median length	6
Mean length	5.704213796
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Street
2nd row	Street
3rd row	Street
4th row	Street
5th row	Street

Common Values

Value	Count	Frequency (%)
Street	209219	25.9%
Avenue	136528	16.9%
Road	120572	15.0%
Drive	101399	12.6%
Crescent	80706	10.0%
Boulevard	53041	6.6%
Bay	33959	4.2%
Place	20535	2.5%
Lane	13529	1.7%
Way	11142	1.4%
Other values (11)	24962	3.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	209219	26.0%
avenue	136528	16.9%
road	120572	15.0%
drive	101399	12.6%
crescent	80706	10.0%
boulevard	53041	6.6%
bay	33959	4.2%
place	20535	2.5%
lane	13529	1.7%
way	11142	1.4%
Other values (11)	24962	3.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

centre.utm.x
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1427
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	635371.5779

Minimum	620638
Maximum	646295
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	620638
5-th percentile	624162
Q1	631653
median	637128
Q3	639803
95-th percentile	641828
Maximum	646295
Range	25657
Interquartile range (IQR)	8150

Descriptive statistics

Standard deviation	5482.328954
Coefficient of variation (CV)	0.00862853981
Kurtosis	-0.3106436468
Mean	635371.5779
Median Absolute Deviation (MAD)	3315
Skewness	-0.7532584124
Sum	5.12373171 × 10¹¹
Variance	30055930.76
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
641356	12635	1.6%
640032	10208	1.3%
640837	9225	1.1%
642520	6342	0.8%
640833	6194	0.8%
634493	6020	0.7%
637736	5880	0.7%
632718	5688	0.7%
639671	5250	0.7%
634092	5243	0.7%
Other values (1417)	733730	91.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
620638	2223	0.3%
620949	7	< 0.1%
620978	168	< 0.1%
620985	184	< 0.1%
620992	28	< 0.1%
621127	154	< 0.1%
621132	141	< 0.1%
621153	320	< 0.1%
621166	2198	0.3%
621168	306	< 0.1%

Value	Count	Frequency (%)
646295	15	< 0.1%
646274	455	0.1%
646258	125	< 0.1%
646235	410	0.1%
646209	310	< 0.1%
646200	20	< 0.1%
646168	95	< 0.1%
645970	1400	0.2%
645939	100	< 0.1%
645537	41	< 0.1%

centre.utm.y
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1408
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5525844.66

Minimum	5514217
Maximum	5536457
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	5514217
5-th percentile	5519264
Q1	5521920
median	5525438
Q3	5528676
95-th percentile	5534266
Maximum	5536457
Range	22240
Interquartile range (IQR)	6756

Descriptive statistics

Standard deviation	4710.352306
Coefficient of variation (CV)	0.0008524221356
Kurtosis	-0.8168962561
Mean	5525844.66
Median Absolute Deviation (MAD)	3328
Skewness	0.3351048887
Sum	4.456124021 × 10¹²
Variance	22187418.85
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5526877	12635	1.6%
5534766	10223	1.3%
5524101	9225	1.1%
5528676	6342	0.8%
5526706	6194	0.8%
5519026	6020	0.7%
5519647	5880	0.7%
5528206	5688	0.7%
5522472	5250	0.7%
5525327	5208	0.6%
Other values (1398)	733750	91.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5514217	1	< 0.1%
5514366	1	< 0.1%
5515525	8	< 0.1%
5515790	12	< 0.1%
5516486	6	< 0.1%
5516690	14	< 0.1%
5516869	15	< 0.1%
5517046	6	< 0.1%
5517197	6	< 0.1%
5517980	160	< 0.1%

Value	Count	Frequency (%)
5536457	848	0.1%
5536440	576	0.1%
5536372	1120	0.1%
5536340	108	< 0.1%
5536338	36	< 0.1%
5536321	656	0.1%
5536284	432	0.1%
5536254	32	< 0.1%
5536175	188	< 0.1%
5536167	48	< 0.1%

centre.geographic.latitude
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1376
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.86966864

Minimum	49.76587
Maximum	49.96631
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	49.76587
5-th percentile	49.81006
Q1	49.83364
median	49.86686
Q3	49.89404
95-th percentile	49.94602
Maximum	49.96631
Range	0.20044
Interquartile range (IQR)	0.0604

Descriptive statistics

Standard deviation	0.0425096182
Coefficient of variation (CV)	0.0008524142903
Kurtosis	-0.8168163374
Mean	49.86966864
Median Absolute Deviation (MAD)	0.03039
Skewness	0.3314309857
Sum	40215648.84
Variance	0.00180706764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49.87759	12635	1.6%
49.94882	10208	1.3%
49.85276	9696	1.2%
49.89349	6342	0.8%
49.87618	6194	0.8%
49.8086	6020	0.7%
49.81344	5880	0.7%
49.89152	5688	0.7%
49.83839	5250	0.7%
49.86533	5208	0.6%
Other values (1366)	733294	90.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
49.76587	1	< 0.1%
49.76696	1	< 0.1%
49.77791	8	< 0.1%
49.78033	12	< 0.1%
49.78601	6	< 0.1%
49.78806	14	< 0.1%
49.7896	15	< 0.1%
49.79113	6	< 0.1%
49.79243	6	< 0.1%
49.79883	160	< 0.1%

Value	Count	Frequency (%)
49.96631	848	0.1%
49.96617	576	0.1%
49.96555	1120	0.1%
49.96525	36	< 0.1%
49.96519	108	< 0.1%
49.96501	656	0.1%
49.96431	432	0.1%
49.96404	32	< 0.1%
49.96379	188	< 0.1%
49.96345	464	0.1%

centre.geographic.longitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1447
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-97.1161436

Minimum	-97.32078
Maximum	-96.96269
Zeros	0
Zeros (%)	0.0%
Negative	806415
Negative (%)	100.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	-97.32078
5-th percentile	-97.27176
Q1	-97.16777
median	-97.09314
Q3	-97.05475
95-th percentile	-97.02525
Maximum	-96.96269
Range	0.35809
Interquartile range (IQR)	0.11302

Descriptive statistics

Standard deviation	0.07608137592
Coefficient of variation (CV)	-0.0007834060651
Kurtosis	-0.2989308886
Mean	-97.1161436
Median Absolute Deviation (MAD)	0.04659
Skewness	-0.7378167741
Sum	-78315914.94
Variance	0.005788375761
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-97.03253	12635	1.6%
-97.04808	10208	1.3%
-97.04076	9225	1.1%
-97.01567	6342	0.8%
-97.03986	6194	0.8%
-97.13072	6020	0.7%
-97.08545	5880	0.7%
-97.15223	5688	0.7%
-97.05297	5473	0.7%
-97.05755	5250	0.7%
Other values (1437)	733500	91.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-97.32078	2223	0.3%
-97.31768	7	< 0.1%
-97.3156	168	< 0.1%
-97.31544	184	< 0.1%
-97.31542	28	< 0.1%
-97.31497	141	< 0.1%
-97.31486	154	< 0.1%
-97.31423	320	< 0.1%
-97.31403	306	< 0.1%
-97.31333	2198	0.3%

Value	Count	Frequency (%)
-96.96269	15	< 0.1%
-96.96296	455	0.1%
-96.96326	125	< 0.1%
-96.96358	410	0.1%
-96.96379	310	< 0.1%
-96.96412	20	< 0.1%
-96.96435	95	< 0.1%
-96.96708	1400	0.2%
-96.96751	100	< 0.1%
-96.97325	12	< 0.1%

Bus_Variant
Categorical

HIGH CARDINALITY

Distinct	242
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

93-0-H	48200
49-1-D	43596
16-0-B	32659
95-0-pp	30527
16-0-M	26730
Other values (237)	624703

Length

Max length	7
Median length	6
Mean length	6.06718253
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	45-0-K
2nd row	45-0-K
3rd row	45-0-K
4th row	45-0-K
5th row	45-0-K

Common Values

Value	Count	Frequency (%)
93-0-H	48200	6.0%
49-1-D	43596	5.4%
16-0-B	32659	4.0%
95-0-pp	30527	3.8%
16-0-M	26730	3.3%
95-1-R	24258	3.0%
95-0-S	21805	2.7%
16-1-L	17780	2.2%
42-1-D	17364	2.2%
58-1-D	16764	2.1%
Other values (232)	526732	65.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
93-0-h	48200	6.0%
49-1-d	43596	5.4%
16-0-b	32659	4.0%
95-0-pp	30527	3.8%
16-0-m	26730	3.3%
95-1-r	24258	3.0%
95-0-s	21805	2.7%
16-1-l	17780	2.2%
42-1-d	17364	2.2%
58-1-d	16764	2.1%
Other values (232)	526732	65.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Variants_Serviced_Count
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.04669432

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	36
Range	35
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.196332845
Coefficient of variation (CV)	0.7208904518
Kurtosis	71.2140043
Mean	3.04669432
Median Absolute Deviation (MAD)	1
Skewness	5.944794601
Sum	2456900
Variance	4.823877965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
2	236571	29.3%
4	162703	20.2%
1	153867	19.1%
3	125034	15.5%
5	59071	7.3%
6	43831	5.4%
7	16070	2.0%
9	6118	0.8%
28	474	0.1%
8	436	0.1%
Other values (12)	2240	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	153867	19.1%
2	236571	29.3%
3	125034	15.5%
4	162703	20.2%
5	59071	7.3%
6	43831	5.4%
7	16070	2.0%
8	436	0.1%
9	6118	0.8%
10	121	< 0.1%

Value	Count	Frequency (%)
36	410	0.1%
35	218	< 0.1%
31	172	< 0.1%
30	134	< 0.1%
29	324	< 0.1%
28	474	0.1%
27	311	< 0.1%
24	124	< 0.1%
23	105	< 0.1%
20	127	< 0.1%

Number_of_Stoppages
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	97
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.5427528

Minimum	9
Maximum	186
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	9
5-th percentile	29
Q1	52
median	68
Q3	96
95-th percentile	153
Maximum	186
Range	177
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	35.72414325
Coefficient of variation (CV)	0.4667214327
Kurtosis	-0.3594675121
Mean	76.5427528
Median Absolute Deviation (MAD)	17
Skewness	0.6894685952
Sum	61725224
Variance	1276.214411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
153	59389	7.4%
61	52088	6.5%
82	49569	6.1%
110	48200	6.0%
124	43716	5.4%
53	36230	4.5%
52	34366	4.3%
83	30562	3.8%
66	29507	3.7%
62	21520	2.7%
Other values (87)	401268	49.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9	983	0.1%
16	2201	0.3%
17	1038	0.1%
18	3	< 0.1%
19	748	0.1%
20	4319	0.5%
21	2068	0.3%
22	6123	0.8%
24	1586	0.2%
25	5914	0.7%

Value	Count	Frequency (%)
186	80	< 0.1%
180	140	< 0.1%
172	100	< 0.1%
153	59389	7.4%
147	153	< 0.1%
146	32	< 0.1%
145	136	< 0.1%
143	17780	2.2%
142	128	< 0.1%
141	119	< 0.1%

Types_of_Features_Count
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	1800
Missing (%)	0.2%
Memory size	12.3 MiB

0.0	591794
1.0	168647
2.0	41035
3.0	3009
4.0	130

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3.0
2nd row	3.0
3rd row	3.0
4th row	3.0
5th row	3.0

Common Values

Value	Count	Frequency (%)
0.0	591794	73.4%
1.0	168647	20.9%
2.0	41035	5.1%
3.0	3009	0.4%
4.0	130	< 0.1%
(Missing)	1800	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0.0	591794	73.5%
1.0	168647	21.0%
2.0	41035	5.1%
3.0	3009	0.4%
4.0	130	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Destination_Name
Categorical

HIGH CARDINALITY

Distinct	150
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Downtown	84532
City Hall	39974
St. Vital Centre	32552
South St. Vital	30342
Balmoral Station	28345
Other values (145)	590670

Length

Max length	28
Median length	11
Mean length	12.52630965
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	City Hall
2nd row	Point Douglas
3rd row	Kildonan Place
4th row	Munroe
5th row	Crossroads Station

Common Values

Value	Count	Frequency (%)
Downtown	84532	10.5%
City Hall	39974	5.0%
St. Vital Centre	32552	4.0%
South St. Vital	30342	3.8%
Balmoral Station	28345	3.5%
Kildonan Place	28090	3.5%
St. Boniface Industrial Park	27820	3.4%
Polo Park	25206	3.1%
Grace Hospital	21767	2.7%
Southglen	21451	2.7%
Other values (140)	466336	57.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
park	135902	8.7%
st	111162	7.1%
downtown	84532	5.4%
centre	63516	4.1%
vital	62894	4.0%
station	47930	3.1%
city	40301	2.6%
hall	39974	2.6%
kildonan	39138	2.5%
industrial	37050	2.4%
Other values (173)	892537	57.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Route_Name
Categorical

HIGH CARDINALITY

Distinct	225
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

to Highbury & Southfields	48200
Dugald to Balmoral Station	43596
Selkirk-Osborne to Tyndall Park via Burrows	32659
to Polo Park	30527
Selkirk-Osborne to Tyndall Park via Manitoba	26730
Other values (220)	624703

Length

Max length	60
Median length	26
Mean length	29.21398039
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Talbot to Kildonan Place
2nd row	Talbot to Kildonan Place
3rd row	Talbot to Kildonan Place
4th row	Talbot to Kildonan Place
5th row	Talbot to Kildonan Place

Common Values

Value	Count	Frequency (%)
to Highbury & Southfields	48200	6.0%
Dugald to Balmoral Station	43596	5.4%
Selkirk-Osborne to Tyndall Park via Burrows	32659	4.0%
to Polo Park	30527	3.8%
Selkirk-Osborne to Tyndall Park via Manitoba	26730	3.3%
to Unicity	26168	3.2%
to Riverview	24258	3.0%
to Shaftesbury Park	21805	2.7%
to St. Vital Centre	21367	2.6%
to Kildonan Place	20507	2.5%
Other values (215)	510598	63.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	805359	21.3%
express	187204	4.9%
via	186522	4.9%
park	180553	4.8%
	124439	3.3%
st	103140	2.7%
selkirk-osborne	94187	2.5%
station	89437	2.4%
dugald	79890	2.1%
balmoral	67907	1.8%
Other values (202)	1866166	49.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Route_Number
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.71088583

Minimum	10
Maximum	694
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	10
5-th percentile	16
Q1	35
median	57
Q3	92
95-th percentile	96
Maximum	694
Range	684
Interquartile range (IQR)	57

Descriptive statistics

Standard deviation	98.5892654
Coefficient of variation (CV)	1.337512964
Kurtosis	31.67685615
Mean	73.71088583
Median Absolute Deviation (MAD)	30
Skewness	5.522138611
Sum	59441564
Variance	9719.843252
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	94187	11.7%
95	76590	9.5%
49	69083	8.6%
93	56267	7.0%
83	44108	5.5%
42	33954	4.2%
15	31806	3.9%
50	31784	3.9%
96	29485	3.7%
59	28496	3.5%
Other values (71)	310655	38.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	76	< 0.1%
11	743	0.1%
12	7	< 0.1%
14	150	< 0.1%
15	31806	3.9%
16	94187	11.7%
17	87	< 0.1%
18	281	< 0.1%
19	153	< 0.1%
20	258	< 0.1%

Value	Count	Frequency (%)
694	5572	0.7%
693	645	0.1%
691	769	0.1%
690	6692	0.8%
677	3454	0.4%
676	12	< 0.1%
672	587	0.1%
671	429	0.1%
662	437	0.1%
650	10	< 0.1%

Variants_Count
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.130321237

Minimum	2
Maximum	11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	3
Q3	4
95-th percentile	11
Maximum	11
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.858363869
Coefficient of variation (CV)	0.692043961
Kurtosis	1.255578661
Mean	4.130321237
Median Absolute Deviation (MAD)	1
Skewness	1.631578047
Sum	3330753
Variance	8.170244007
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
3	349102	43.3%
2	219455	27.2%
11	98677	12.2%
4	58063	7.2%
6	45335	5.6%
7	31959	4.0%
8	2760	0.3%
10	743	0.1%
5	321	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	219455	27.2%
3	349102	43.3%
4	58063	7.2%
5	321	< 0.1%
6	45335	5.6%
7	31959	4.0%
8	2760	0.3%
10	743	0.1%
11	98677	12.2%

Value	Count	Frequency (%)
11	98677	12.2%
10	743	0.1%
8	2760	0.3%
7	31959	4.0%
6	45335	5.6%
5	321	< 0.1%
4	58063	7.2%
3	349102	43.3%
2	219455	27.2%

Route_Description
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	81
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Route 16 Selkirk-Osborne	94187
Route 95 Tuxedo - Riverview	76590
Route 49 Dugald	69083
Route 93 South St. Vital - St. Marys	56267
Route 83 Unicity - Strauss Dr - Murray Industrial Park	44108
Other values (76)	466180

Length

Max length	54
Median length	26
Mean length	28.24824935
Min length	13

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Route 45 Talbot
2nd row	Route 45 Talbot
3rd row	Route 45 Talbot
4th row	Route 45 Talbot
5th row	Route 45 Talbot

Common Values

Value	Count	Frequency (%)
Route 16 Selkirk-Osborne	94187	11.7%
Route 95 Tuxedo - Riverview	76590	9.5%
Route 49 Dugald	69083	8.6%
Route 93 South St. Vital - St. Marys	56267	7.0%
Route 83 Unicity - Strauss Dr - Murray Industrial Park	44108	5.5%
Route 42 Plessis Express	33954	4.2%
Route 15 Sargent-Mountain	31806	3.9%
Route 50 Archibald	31784	3.9%
Route 96 St. Vital Centre - Windsor Park	29485	3.7%
Route 59 South St. Anne's Express	28496	3.5%
Other values (71)	310655	38.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
route	806415	20.2%
	358150	9.0%
express	203344	5.1%
st	194757	4.9%
16	94187	2.4%
selkirk-osborne	94187	2.4%
park	87897	2.2%
vital	85752	2.1%
south	84763	2.1%
industrial	77612	1.9%
Other values (172)	1912957	47.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

coverage
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

regular	584456
express	188079
feeder	18615
super express	15265

Length

Max length	13
Median length	7
Mean length	7.090493108
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	regular
2nd row	regular
3rd row	regular
4th row	regular
5th row	regular

Common Values

Value	Count	Frequency (%)
regular	584456	72.5%
express	188079	23.3%
feeder	18615	2.3%
super express	15265	1.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
regular	584456	71.1%
express	203344	24.7%
feeder	18615	2.3%
super	15265	1.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

key
Categorical

HIGH CARDINALITY

Distinct	16008
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

22722441-50	297
22722539-35	282
22720730-20	277
22721860-46	255
22722789-44	250
Other values (16003)	805054

Length

Max length	12
Median length	11
Mean length	10.86067471
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	194 ?
Unique (%)	< 0.1%

Sample

1st row	22721732-6
2nd row	22721732-6
3rd row	22721732-6
4th row	22721732-6
5th row	22721732-6

Common Values

Value	Count	Frequency (%)
22722441-50	297	< 0.1%
22722539-35	282	< 0.1%
22720730-20	277	< 0.1%
22721860-46	255	< 0.1%
22722789-44	250	< 0.1%
22722777-42	244	< 0.1%
22722163-36	243	< 0.1%
22722448-62	243	< 0.1%
22721329-40	240	< 0.1%
22722882-2	240	< 0.1%
Other values (15998)	803844	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
22722441-50	297	< 0.1%
22722539-35	282	< 0.1%
22720730-20	277	< 0.1%
22721860-46	255	< 0.1%
22722789-44	250	< 0.1%
22722777-42	244	< 0.1%
22722163-36	243	< 0.1%
22722448-62	243	< 0.1%
22721329-40	240	< 0.1%
22722882-2	240	< 0.1%
Other values (15998)	803844	99.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

cancelled
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

False	806415

Common Values
Chart

Value	Count	Frequency (%)
False	806415	100.0%

times.departure.scheduled
Categorical

HIGH CARDINALITY

Distinct	7389
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

2022-12-26T12:39:00	1484
2022-12-26T12:25:00	1218
2022-12-26T12:13:00	1169
2022-12-26T13:09:00	1132
2022-12-26T12:22:00	1131
Other values (7384)	800281

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	41 ?
Unique (%)	< 0.1%

Sample

1st row	2022-12-26T12:24:00
2nd row	2022-12-26T12:24:00
3rd row	2022-12-26T12:24:00
4th row	2022-12-26T12:24:00
5th row	2022-12-26T12:24:00

Common Values

Value	Count	Frequency (%)
2022-12-26T12:39:00	1484	0.2%
2022-12-26T12:25:00	1218	0.2%
2022-12-26T12:13:00	1169	0.1%
2022-12-26T13:09:00	1132	0.1%
2022-12-26T12:22:00	1131	0.1%
2022-12-26T12:29:00	1089	0.1%
2022-12-26T12:48:00	979	0.1%
2022-12-26T13:02:00	966	0.1%
2022-12-26T12:15:00	952	0.1%
2022-12-26T12:44:00	946	0.1%
Other values (7379)	795349	98.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-12-26t12:39:00	1484	0.2%
2022-12-26t12:25:00	1218	0.2%
2022-12-26t12:13:00	1169	0.1%
2022-12-26t13:09:00	1132	0.1%
2022-12-26t12:22:00	1131	0.1%
2022-12-26t12:29:00	1089	0.1%
2022-12-26t12:48:00	979	0.1%
2022-12-26t13:02:00	966	0.1%
2022-12-26t12:15:00	952	0.1%
2022-12-26t12:44:00	946	0.1%
Other values (7379)	795349	98.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

times.departure.estimated
Categorical

HIGH CARDINALITY

Distinct	7391
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

2022-12-26T12:39:00	1484
2022-12-26T12:25:00	1218
2022-12-26T12:13:00	1142
2022-12-26T13:09:00	1132
2022-12-26T12:22:00	1131
Other values (7386)	800308

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	42 ?
Unique (%)	< 0.1%

Sample

1st row	2022-12-26T12:24:00
2nd row	2022-12-26T12:24:00
3rd row	2022-12-26T12:24:00
4th row	2022-12-26T12:24:00
5th row	2022-12-26T12:24:00

Common Values

Value	Count	Frequency (%)
2022-12-26T12:39:00	1484	0.2%
2022-12-26T12:25:00	1218	0.2%
2022-12-26T12:13:00	1142	0.1%
2022-12-26T13:09:00	1132	0.1%
2022-12-26T12:22:00	1131	0.1%
2022-12-26T12:29:00	1089	0.1%
2022-12-26T12:15:00	989	0.1%
2022-12-26T12:48:00	979	0.1%
2022-12-26T13:02:00	966	0.1%
2022-12-26T12:44:00	946	0.1%
Other values (7381)	795339	98.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-12-26t12:39:00	1484	0.2%
2022-12-26t12:25:00	1218	0.2%
2022-12-26t12:13:00	1142	0.1%
2022-12-26t13:09:00	1132	0.1%
2022-12-26t12:22:00	1131	0.1%
2022-12-26t12:29:00	1089	0.1%
2022-12-26t12:15:00	989	0.1%
2022-12-26t12:48:00	979	0.1%
2022-12-26t13:02:00	966	0.1%
2022-12-26t12:44:00	946	0.1%
Other values (7381)	795339	98.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

variant.key
Categorical

HIGH CARDINALITY

Distinct	108
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

18-1-A	22419
14-1-E	17227
77-1-K	15549
15-0-W	15448
77-0-P	14902
Other values (103)	720870

Length

Max length	8
Median length	6
Mean length	6.253889127
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	45-0-K
2nd row	45-0-K
3rd row	45-0-K
4th row	45-0-K
5th row	45-0-K

Common Values

Value	Count	Frequency (%)
18-1-A	22419	2.8%
14-1-E	17227	2.1%
77-1-K	15549	1.9%
15-0-W	15448	1.9%
77-0-P	14902	1.8%
17-1-MH	14347	1.8%
47-1-U	14092	1.7%
15-1-L	13841	1.7%
11-0-C	13712	1.7%
11-0-S	13508	1.7%
Other values (98)	651370	80.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
18-1-a	22419	2.8%
14-1-e	17227	2.1%
77-1-k	15549	1.9%
15-0-w	15448	1.9%
77-0-p	14902	1.8%
17-1-mh	14347	1.8%
47-1-u	14092	1.7%
15-1-l	13841	1.7%
11-0-c	13712	1.7%
11-0-s	13508	1.7%
Other values (98)	651370	80.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

variant.name
Categorical

HIGH CARDINALITY

Distinct	107
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

North Main-Corydon to Assiniboine Park	22419
St. Mary's-Ellice to Ferry Road	17227
Crosstown North to Kildonan Place	15549
Sargent-Mountain to Airport via Wellington	15448
Crosstown North to Polo Park	14902
Other values (102)	720870

Length

Max length	67
Median length	34
Mean length	35.44341561
Min length	11

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Talbot to Kildonan Place
2nd row	Talbot to Kildonan Place
3rd row	Talbot to Kildonan Place
4th row	Talbot to Kildonan Place
5th row	Talbot to Kildonan Place

Common Values

Value	Count	Frequency (%)
North Main-Corydon to Assiniboine Park	22419	2.8%
St. Mary's-Ellice to Ferry Road	17227	2.1%
Crosstown North to Kildonan Place	15549	1.9%
Sargent-Mountain to Airport via Wellington	15448	1.9%
Crosstown North to Polo Park	14902	1.8%
McGregor to Misericordia Health Centre	14347	1.8%
Transcona - Pembina to University of Manitoba via Downtown	14092	1.7%
Sargent-Mountain to Mountain & Fife	13841	1.7%
Portage-Kildonan to Crestview via	13712	1.7%
Portage-Kildonan to St. Charles via	13508	1.7%
Other values (97)	651370	80.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	806415	18.8%
via	413540	9.6%
park	129352	3.0%
st	106996	2.5%
north	105392	2.5%
portage-kildonan	94737	2.2%
	82457	1.9%
centre	77192	1.8%
kildonan	77153	1.8%
manitoba	72391	1.7%
Other values (132)	2329817	54.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

bus.key
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	120
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	529.7491825

Minimum	101
Maximum	883
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 MiB

Quantile statistics

Minimum	101
5-th percentile	131
Q1	320
median	432
Q3	801
95-th percentile	871
Maximum	883
Range	782
Interquartile range (IQR)	481

Descriptive statistics

Standard deviation	266.6493154
Coefficient of variation (CV)	0.5033501216
Kurtosis	-1.551773477
Mean	529.7491825
Median Absolute Deviation (MAD)	271
Skewness	-0.09395973129
Sum	427197687
Variance	71101.85743
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
605	10009	1.2%
837	9851	1.2%
770	9664	1.2%
808	9621	1.2%
839	9491	1.2%
300	9456	1.2%
191	9366	1.2%
131	9142	1.1%
635	9113	1.1%
702	8759	1.1%
Other values (110)	711943	88.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
101	8488	1.1%
106	7770	1.0%
110	6386	0.8%
125	5179	0.6%
129	6656	0.8%
131	9142	1.1%
142	7179	0.9%
145	4939	0.6%
160	6808	0.8%
161	8365	1.0%

Value	Count	Frequency (%)
883	6851	0.8%
879	8453	1.0%
878	6876	0.9%
877	7947	1.0%
875	5391	0.7%
871	7298	0.9%
870	7731	1.0%
864	4264	0.5%
863	8693	1.1%
861	7112	0.9%

bus.bike-rack
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

False	668753
True	137662

Common Values
Chart

Value	Count	Frequency (%)
False	668753	82.9%
True	137662	17.1%

bus.wifi
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

False	806415

Common Values
Chart

Value	Count	Frequency (%)
False	806415	100.0%

times.arrival.scheduled
Categorical

HIGH CARDINALITY

Distinct	7389
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

2022-12-26T12:39:00	1484
2022-12-26T12:25:00	1218
2022-12-26T12:13:00	1169
2022-12-26T13:09:00	1132
2022-12-26T12:22:00	1131
Other values (7384)	800281

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	41 ?
Unique (%)	< 0.1%

Sample

1st row	2022-12-26T12:24:00
2nd row	2022-12-26T12:24:00
3rd row	2022-12-26T12:24:00
4th row	2022-12-26T12:24:00
5th row	2022-12-26T12:24:00

Common Values

Value	Count	Frequency (%)
2022-12-26T12:39:00	1484	0.2%
2022-12-26T12:25:00	1218	0.2%
2022-12-26T12:13:00	1169	0.1%
2022-12-26T13:09:00	1132	0.1%
2022-12-26T12:22:00	1131	0.1%
2022-12-26T12:29:00	1089	0.1%
2022-12-26T12:48:00	979	0.1%
2022-12-26T13:02:00	966	0.1%
2022-12-26T12:15:00	952	0.1%
2022-12-26T12:44:00	946	0.1%
Other values (7379)	795349	98.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-12-26t12:39:00	1484	0.2%
2022-12-26t12:25:00	1218	0.2%
2022-12-26t12:13:00	1169	0.1%
2022-12-26t13:09:00	1132	0.1%
2022-12-26t12:22:00	1131	0.1%
2022-12-26t12:29:00	1089	0.1%
2022-12-26t12:48:00	979	0.1%
2022-12-26t13:02:00	966	0.1%
2022-12-26t12:15:00	952	0.1%
2022-12-26t12:44:00	946	0.1%
Other values (7379)	795349	98.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

times.arrival.estimated
Categorical

HIGH CARDINALITY

Distinct	7391
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

2022-12-26T12:39:00	1484
2022-12-26T12:25:00	1218
2022-12-26T12:13:00	1142
2022-12-26T13:09:00	1132
2022-12-26T12:22:00	1131
Other values (7386)	800308

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	42 ?
Unique (%)	< 0.1%

Sample

1st row	2022-12-26T12:24:00
2nd row	2022-12-26T12:24:00
3rd row	2022-12-26T12:24:00
4th row	2022-12-26T12:24:00
5th row	2022-12-26T12:24:00

Common Values

Value	Count	Frequency (%)
2022-12-26T12:39:00	1484	0.2%
2022-12-26T12:25:00	1218	0.2%
2022-12-26T12:13:00	1142	0.1%
2022-12-26T13:09:00	1132	0.1%
2022-12-26T12:22:00	1131	0.1%
2022-12-26T12:29:00	1089	0.1%
2022-12-26T12:15:00	989	0.1%
2022-12-26T12:48:00	979	0.1%
2022-12-26T13:02:00	966	0.1%
2022-12-26T12:44:00	946	0.1%
Other values (7381)	795339	98.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-12-26t12:39:00	1484	0.2%
2022-12-26t12:25:00	1218	0.2%
2022-12-26t12:13:00	1142	0.1%
2022-12-26t13:09:00	1132	0.1%
2022-12-26t12:22:00	1131	0.1%
2022-12-26t12:29:00	1089	0.1%
2022-12-26t12:15:00	989	0.1%
2022-12-26t12:48:00	979	0.1%
2022-12-26t13:02:00	966	0.1%
2022-12-26t12:44:00	946	0.1%
Other values (7381)	795339	98.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Delay_Time
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	476
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.228166639

Minimum	-4018
Maximum	916
Zeros	754106
Zeros (%)	93.5%
Negative	10622
Negative (%)	1.3%
Memory size	12.3 MiB

Quantile statistics

Minimum	-4018
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	5
Maximum	916
Range	4934
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	57.13950206
Coefficient of variation (CV)	7.905116874
Kurtosis	633.4342755
Mean	7.228166639
Median Absolute Deviation (MAD)	0
Skewness	-3.784144776
Sum	5828902
Variance	3264.922696
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	754106	93.5%
3	490	0.1%
-2	440	0.1%
65	439	0.1%
24	435	0.1%
63	428	0.1%
83	413	0.1%
114	393	< 0.1%
55	385	< 0.1%
-16	381	< 0.1%
Other values (466)	48505	6.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4018	18	< 0.1%
-1065	64	< 0.1%
-999	94	< 0.1%
-926	110	< 0.1%
-237	8	< 0.1%
-214	54	< 0.1%
-209	54	< 0.1%
-187	32	< 0.1%
-182	52	< 0.1%
-177	41	< 0.1%

Value	Count	Frequency (%)
916	60	< 0.1%
831	9	< 0.1%
828	15	< 0.1%
803	28	< 0.1%
801	12	< 0.1%
789	48	< 0.1%
767	21	< 0.1%
760	135	< 0.1%
754	32	< 0.1%
714	49	< 0.1%

IsDelayed
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

False	754106
True	52309

Common Values
Chart

Value	Count	Frequency (%)
False	754106	93.5%
True	52309	6.5%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Stop_Name	Stop_Number	direction	side	street.key	street.name	street.type	cross-street.key	cross-street.name	cross-street.type	centre.utm.x	centre.utm.y	centre.geographic.latitude	centre.geographic.longitude	Bus_Variant	Variants_Serviced_Count	Number_of_Stoppages	Types_of_Features_Count	Destination_Name	Route_Name	Route_Number	Variants_Count	Route_Description	coverage	key	cancelled	times.departure.scheduled	times.departure.estimated	variant.key	variant.name	bus.key	bus.bike-rack	bus.wifi	times.arrival.scheduled	times.arrival.estimated	IsDelayed
0	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	45-0-K	30.0	57	3.0	City Hall	Talbot to Kildonan Place	45.0	3	Route 45 Talbot	regular	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
1	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	45-0-K	30.0	57	3.0	Point Douglas	Talbot to Kildonan Place	45.0	3	Route 45 Talbot	regular	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
2	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	45-0-K	30.0	57	3.0	Kildonan Place	Talbot to Kildonan Place	45.0	3	Route 45 Talbot	regular	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
3	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	45-0-K	30.0	57	3.0	Munroe	Talbot to Kildonan Place	45.0	3	Route 45 Talbot	regular	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
4	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	45-0-K	30.0	57	3.0	Crossroads Station	Talbot to Kildonan Place	45.0	3	Route 45 Talbot	regular	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
5	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	35-1-C	30.0	48	3.0	City Hall	to City Hall	35.0	2	Route 35 Maples Super Express	super express	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
6	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	35-1-C	30.0	48	3.0	Maples	to City Hall	35.0	2	Route 35 Maples Super Express	super express	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
7	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	35-1-C	30.0	48	3.0	Downtown	to City Hall	35.0	2	Route 35 Maples Super Express	super express	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
8	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	35-1-C	30.0	48	3.0	Health Sciences Centre	to City Hall	35.0	2	Route 35 Maples Super Express	super express	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False
9	Eastbound Graham at Smith	10615.0	Eastbound	Nearside	1533.0	Graham Avenue	Avenue	3371.0	Smith Street	Street	633485.0	5528315.0	49.89232	-97.14152	16-0-B	30.0	153	3.0	Fife	Selkirk-Osborne to Tyndall Park via Burrows	16.0	11	Route 16 Selkirk-Osborne	regular	22721732-6	False	2022-12-26T12:24:00	2022-12-26T12:24:00	45-0-K	Talbot to Kildonan Place	359.0	False	False	2022-12-26T12:24:00	2022-12-26T12:24:00	False

Last rows

	Stop_Name	Stop_Number	direction	side	street.key	street.name	street.type	cross-street.key	cross-street.name	cross-street.type	centre.utm.x	centre.utm.y	centre.geographic.latitude	centre.geographic.longitude	Bus_Variant	Variants_Serviced_Count	Number_of_Stoppages	Destination_Name	Route_Name	Route_Number	Variants_Count	Route_Description	coverage	key	cancelled	times.departure.scheduled	times.departure.estimated	variant.key	variant.name	bus.key	bus.bike-rack	bus.wifi	times.arrival.scheduled	times.arrival.estimated	IsDelayed
806405	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22720722-16	False	2022-12-26T11:29:44	2022-12-26T11:29:44	BLUE-1-D	BLUE to Downtown	397.0	True	False	2022-12-26T11:29:44	2022-12-26T11:29:44	False
806406	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22722501-6	False	2022-12-26T13:35:27	2022-12-26T13:35:27	15-0-W	Sargent-Mountain to Airport via Wellington	161.0	True	False	2022-12-26T13:35:27	2022-12-26T13:35:27	False
806407	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22721276-47	False	2022-12-26T13:23:01	2022-12-26T13:23:01	79-1-K	Charleswood to Polo Park via Kenaston	432.0	True	False	2022-12-26T13:23:01	2022-12-26T13:23:01	False
806408	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22722883-27	False	2022-12-26T13:26:40	2022-12-26T13:26:40	10-0-SP	St. Boniface-Wolseley to St. Boniface via Provencher	171.0	False	False	2022-12-26T13:26:40	2022-12-26T13:26:40	False
806409	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22722770-114	False	2022-12-26T13:16:22	2022-12-26T13:16:22	11-1-D	Portage-Kildonan to North Kildonan via Donwood	635.0	False	False	2022-12-26T13:16:22	2022-12-26T13:16:22	False
806410	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22720726-15	False	2022-12-26T12:13:35	2022-12-26T12:13:35	BLUE-1-D	BLUE to Downtown	376.0	True	False	2022-12-26T12:13:35	2022-12-26T12:13:35	False
806411	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22722250-4	False	2022-12-26T13:28:26	2022-12-26T13:28:26	18-0-J	North Main-Corydon to Garden City Centre via Jefferson	778.0	False	False	2022-12-26T13:28:26	2022-12-26T13:28:26	False
806412	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22722094-27	False	2022-12-26T13:05:22	2022-12-26T13:05:22	24-1-P	Ness Express to Polo Park	837.0	False	False	2022-12-26T13:05:22	2022-12-26T13:05:22	False
806413	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22721967-56	False	2022-12-26T12:20:00	2022-12-26T12:20:00	33-1-D2	to Downtown	336.0	False	False	2022-12-26T12:20:00	2022-12-26T12:20:00	False
806414	Southbound Buchanan at Peltier	20439.0	Southbound	Nearside Opposite	547.0	Buchanan Boulevard	Boulevard	2817.0	Peltier Avenue	Avenue	620978.0	5528227.0	49.89419	-97.3156	83-0-U	1.0	72	Crestview	to Unicity	83.0	6	Route 83 Unicity - Strauss Dr - Murray Industrial Park	regular	22721897-56	False	2022-12-26T12:02:49	2022-12-26T12:02:49	38-1-F	Salter to The Forks	419.0	True	False	2022-12-26T12:02:49	2022-12-26T12:02:49	False

Most frequently occurring

	Stop_Name	Stop_Number	direction	side	street.key	street.name	street.type	cross-street.key	cross-street.name	cross-street.type	centre.utm.x	centre.utm.y	centre.geographic.latitude	centre.geographic.longitude	Bus_Variant	Variants_Serviced_Count	Number_of_Stoppages	Types_of_Features_Count	Destination_Name	Route_Name	Route_Number	Variants_Count	Route_Description	coverage	key	cancelled	times.departure.scheduled	times.departure.estimated	variant.key	variant.name	bus.key	bus.bike-rack	bus.wifi	times.arrival.scheduled	times.arrival.estimated	IsDelayed	# duplicates
3553	Eastbound Camiel Sys at Ray Marius	50994.0	Eastbound	Nearside	616.0	Camiel Sys Street	Street	3000.0	Ray Marius Road	Road	640833.0	5526706.0	49.87618	-97.03986	49-1-D	4.0	124	0.0	Balmoral Station	Dugald to Balmoral Station	49.0	3	Route 49 Dugald	regular	22722448-9	False	2022-12-26T11:45:41	2022-12-26T11:45:41	16-1-V	Selkirk-Osborne to St.Vital Centre	735.0	False	False	2022-12-26T11:45:41	2022-12-26T11:45:41	False	12
3871	Eastbound Camiel Sys at Ray Marius	50994.0	Eastbound	Nearside	616.0	Camiel Sys Street	Street	3000.0	Ray Marius Road	Road	640833.0	5526706.0	49.87618	-97.03986	49-1-D	4.0	124	0.0	Downtown	Dugald to Balmoral Station	49.0	3	Route 49 Dugald	regular	22722448-9	False	2022-12-26T11:45:41	2022-12-26T11:45:41	16-1-V	Selkirk-Osborne to St.Vital Centre	735.0	False	False	2022-12-26T11:45:41	2022-12-26T11:45:41	False	12
4189	Eastbound Camiel Sys at Ray Marius	50994.0	Eastbound	Nearside	616.0	Camiel Sys Street	Street	3000.0	Ray Marius Road	Road	640833.0	5526706.0	49.87618	-97.03986	49-1-D	4.0	124	0.0	St. Boniface Industrial Park	Dugald to Balmoral Station	49.0	3	Route 49 Dugald	regular	22722448-9	False	2022-12-26T11:45:41	2022-12-26T11:45:41	16-1-V	Selkirk-Osborne to St.Vital Centre	735.0	False	False	2022-12-26T11:45:41	2022-12-26T11:45:41	False	12
5904	Eastbound Portage at Donald (Canada Life Centre)	10582.0	Eastbound	Nearside	2903.0	Portage Avenue	Avenue	1070.0	Donald Street	Street	633334.0	5528442.0	49.89350	-97.14358	41-0-G	35.0	75	3.0	City Hall	Henderson Express to Glenway	41.0	3	Route 41 Henderson Express	express	22722539-35	False	2022-12-26T13:06:30	2022-12-26T13:06:30	15-1-L	Sargent-Mountain to Mountain & Fife	161.0	True	False	2022-12-26T13:06:30	2022-12-26T13:06:30	False	9
5905	Eastbound Portage at Donald (Canada Life Centre)	10582.0	Eastbound	Nearside	2903.0	Portage Avenue	Avenue	1070.0	Donald Street	Street	633334.0	5528442.0	49.89350	-97.14358	41-0-G	35.0	75	3.0	Downtown	Henderson Express to Glenway	41.0	3	Route 41 Henderson Express	express	22722539-35	False	2022-12-26T13:06:30	2022-12-26T13:06:30	15-1-L	Sargent-Mountain to Mountain & Fife	161.0	True	False	2022-12-26T13:06:30	2022-12-26T13:06:30	False	9
5906	Eastbound Portage at Donald (Canada Life Centre)	10582.0	Eastbound	Nearside	2903.0	Portage Avenue	Avenue	1070.0	Donald Street	Street	633334.0	5528442.0	49.89350	-97.14358	41-0-G	35.0	75	3.0	Glenway	Henderson Express to Glenway	41.0	3	Route 41 Henderson Express	express	22722539-35	False	2022-12-26T13:06:30	2022-12-26T13:06:30	15-1-L	Sargent-Mountain to Mountain & Fife	161.0	True	False	2022-12-26T13:06:30	2022-12-26T13:06:30	False	9
5907	Eastbound Portage at Donald (Canada Life Centre)	10582.0	Eastbound	Nearside	2903.0	Portage Avenue	Avenue	1070.0	Donald Street	Street	633334.0	5528442.0	49.89350	-97.14358	41-0-G	35.0	75	3.0	Whellams Lane	Henderson Express to Glenway	41.0	3	Route 41 Henderson Express	express	22722539-35	False	2022-12-26T13:06:30	2022-12-26T13:06:30	15-1-L	Sargent-Mountain to Mountain & Fife	161.0	True	False	2022-12-26T13:06:30	2022-12-26T13:06:30	False	9
15	Eastbound Aldgate at Abbotsfield	50947.0	Eastbound	Nearside Opposite	52.0	Aldgate Road	Road	1.0	Abbotsfield Drive	Drive	638266.0	5519550.0	49.81245	-97.07812	93-0-H	4.0	110	0.0	Dakota	to Highbury & Southfields	93.0	2	Route 93 South St. Vital - St. Marys	regular	22720729-35	False	2022-12-26T12:56:35	2022-12-26T12:56:35	BLUE-1-D	BLUE to Downtown	379.0	True	False	2022-12-26T12:56:35	2022-12-26T12:56:35	False	8
50	Eastbound Aldgate at Abbotsfield	50947.0	Eastbound	Nearside Opposite	52.0	Aldgate Road	Road	1.0	Abbotsfield Drive	Drive	638266.0	5519550.0	49.81245	-97.07812	93-0-H	4.0	110	0.0	Paddington	to Highbury & Southfields	93.0	2	Route 93 South St. Vital - St. Marys	regular	22720729-35	False	2022-12-26T12:56:35	2022-12-26T12:56:35	BLUE-1-D	BLUE to Downtown	379.0	True	False	2022-12-26T12:56:35	2022-12-26T12:56:35	False	8
85	Eastbound Aldgate at Abbotsfield	50947.0	Eastbound	Nearside Opposite	52.0	Aldgate Road	Road	1.0	Abbotsfield Drive	Drive	638266.0	5519550.0	49.81245	-97.07812	93-0-H	4.0	110	0.0	South St. Vital	to Highbury & Southfields	93.0	2	Route 93 South St. Vital - St. Marys	regular	22720729-35	False	2022-12-26T12:56:35	2022-12-26T12:56:35	BLUE-1-D	BLUE to Downtown	379.0	True	False	2022-12-26T12:56:35	2022-12-26T12:56:35	False	8

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters